package cloud.xiguapi.ubas.mapper;

import cloud.xiguapi.ubas.entity.FileHotPages;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Select;

/**
 * 离线热门页面Mapper
 *
 * @author 大大大西西瓜皮🍉
 * date: 2021-5-20 下午 02:58
 * desc:
 */
public interface FileHotPagesMapper extends BaseMapper<FileHotPages> {

    @Select("select fhp.window_end, fhp.details from file_hot_pages fhp")
    IPage<FileHotPages> selectPage(Page<FileHotPages> page);

    @Select("select fhp.window_end from file_hot_pages fhp order by window_end desc")
    IPage<FileHotPages> selectWindowEndPage(Page<FileHotPages> page);
}
